<cfparam name="sendEmail" type="boolean" default="false">

<cfquery name="GetScholarshipClaimsWithoutClassSchedule" datasource="#datasourcename#">
	select *
	from scholarship_claims
	where classschedule = 0
	order by graceperioddays desc, deadlinedate
</cfquery>

<table border="1">
	<tr>
		<td>ClaimID</td>
		<td>Name</td>
		<td>Email</td>
		<td>Home Phone</td>
		<td>Cell Phone</td>
		<td>Enrollment Date</td>
		<td>Date Submitted</td>
		<td>Original Deadline</td>
		<td>Days To Go</td>
		<td>Grace Period Days</td>
		<td>Adjusted Deadline</td>
		<td>Adj. Days To Go</td>
		<td>Group</td>
	</tr>
<cfoutput query="GetScholarshipClaimsWithoutClassSchedule">
	<cfset daysToGo = DateDiff('d', DateFormat(now()), DateFormat(deadlinedate))>
	<cfif DateFormat(enrollmentDate) gte DateFormat(dateSubmitted)>
		<cfset origDeadline = DateAdd('d', 14, enrollmentDate)>
	<cfelse>
		<cfset origDeadline = DateAdd('d', 14, dateSubmitted)>
	</cfif>
	<cfset origDaysToGo = DateDiff('d', DateFormat(now()), DateFormat(origDeadline))>
	<tr>
		<td>#claimID#</td>
		<td>#firstName# #lastName#</td>
		<td>#email#</td>
		<td>#homePhone#</td>
		<td>#cellPhone#</td>
		<td>#DateFormat(enrollmentDate)#</td>
		<td>#DateFormat(dateSubmitted)#</td>
		<td>#DateFormat(origDeadline)#</td>
		<td>#origDaysToGo#</td>
		<td>#graceperioddays#</td>
		<td>#DateFormat(deadlineDate)#</td>
		<td>#daysToGo#</td>
		<td>#graceGroup#</td>
	</tr>
</cfoutput>
</table>

<cfif sendEmail>
	<cfoutput query="GetScholarshipClaimsWithoutClassSchedule">
		<cfset daysToGo = DateDiff('d', DateFormat(now()), DateFormat(deadlinedate))>
		<cfif DateFormat(enrollmentDate) gte DateFormat(dateSubmitted)>
			<cfset origDeadline = DateAdd('d', 14, enrollmentDate)>
		<cfelse>
			<cfset origDeadline = DateAdd('d', 14, dateSubmitted)>
		</cfif>
		<cfset origDaysToGo = DateDiff('d', DateFormat(now()), DateFormat(origDeadline))>
		
		<cfif graceGroup eq 1>
			<cfif DateFormat(now()) eq "02-Jul-08">	
<!--- <cfmail to="#email#" from="cashforcollege@lachamber.org" subject="LAST CHANCE to Complete Your Scholarship Process!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>We haven't received your Fall 2008 class schedule and cannot award your Cash for College scholarship until we do. We are offering you a 5 day grace period to complete the process. Please contact us about your situation right away, if your enrollment date has changed for any reason, or if you are having difficulties getting your fall schedule printed out and faxed to us. If we do not receive your class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, you will forfeit your scholarship.</p>

<p>Please either fax or mail your class schedule to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>Please e-mail the Cash for College scholarship office detailing your situation at <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>. Please remember to include your scholarship claim id number in your email.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail> graceGroup 1 - one time<br> --->
			<cfelseif daysToGo eq 4>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="REMINDER: 4 Days to Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>Your deadline to send us your Fall 2008 class schedule is just 4 days away - #DateFormat(deadlineDate, 'mmmm d, yyyy')#. Don't wait any longer to send it in!  We can't award your scholarship until we receive your class schedule.</p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers faxing services, and fax your fall class schedule to us.</p> 

<p>Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. </p>

<p>E-mail us as soon as possible if you have questions or concerns about sending us your schedule. E-mail <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>, and please remember to include your scholarship claim id number in your email. You can also refresh your memory about the Cash for College scholarship at our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail>	graceGroup 1 - 4 day reminder<br>
			<cfelseif daysToGo eq 2>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="2 Days LEFT Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>Your deadline to send us your Fall 2008 class schedule is just 2 days away - #DateFormat(deadlineDate, 'mmmm d, yyyy')#. Don't wait a minute longer to send us your class schedule! We can't award your scholarship until we receive your class schedule.</p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers Faxing services, and fax your fall class schedule to us.</p> 

<p>Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. </p>

<p>E-mail us as soon as possible if you have questions or concerns about sending us your schedule. E-mail <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>, and please remember to include your scholarship claim id number in your email. You can also refresh your memory about the Cash for College scholarship at our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail>	graceGroup 1 - 2 day reminder<br>
			</cfif>		
		<cfelseif graceGroup eq 2>
			<cfif DateFormat(now()) eq "02-Jul-08">
<!--- <cfmail to="#email#" from="cashforcollege@lachamber.org" subject="#daysToGo# Days to Complete Your Scholarship Process!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>We haven't received your Fall 2008 class schedule and cannot award your Cash for College scholarship until we do. We are offering you an additional 5 day grace period to complete the process. Please contact us about your situation right away, if your enrollment date has changed for any reason, or if you are having difficulties getting your fall schedule printed out and faxed to us. If we do not receive your class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, you will forfeit your scholarship.</p>

<p>Please either fax or mail your class schedule to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>Please e-mail the Cash for College scholarship office detailing your situation at <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>. Please remember to include your scholarship claim id number in your email.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail> graceGroup 2 - one time<br> --->
			<cfelseif daysToGo eq 4>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="REMINDER: 4 Days to Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>Your deadline to send us your Fall 2008 class schedule is just 4 days away - #DateFormat(deadlineDate, 'mmmm d, yyyy')#. Don't wait any longer to send it in!  We can't award your scholarship until we receive your class schedule.</p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers faxing services, and fax your fall class schedule to us.</p> 

<p>Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. </p>

<p>E-mail us as soon as possible if you have questions or concerns about sending us your schedule. E-mail <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>, and please remember to include your scholarship claim id number in your email. You can also refresh your memory about the Cash for College scholarship at our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail> graceGroup 2 - 4 day reminder<br>
			<cfelseif daysToGo eq 2>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="2 Days LEFT Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>Your deadline to send us your Fall 2008 class schedule is just 2 days away - #DateFormat(deadlineDate, 'mmmm d, yyyy')#. Don't wait a minute longer to send us your class schedule! We can't award your scholarship until we receive your class schedule.</p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers Faxing services, and fax your fall class schedule to us.</p> 

<p>Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. </p>

<p>E-mail us as soon as possible if you have questions or concerns about sending us your schedule. E-mail <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>, and please remember to include your scholarship claim id number in your email. You can also refresh your memory about the Cash for College scholarship at our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail>	graceGroup 2 - 2 day reminder<br>
			</cfif>	
		<cfelseif graceGroup eq 3>
			<cfif DateFormat(now()) eq "02-Jul-08">
<!--- <cfmail to="#email#" from="cashforcollege@lachamber.org" subject="10 Days to Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>We haven't received your Fall 2008 class schedule and cannot award your Cash for College scholarship until we do. We are offering you an additional #gracePeriodDays# day grace period to complete the process.  You now have 10 days to complete the process. Please contact us about your situation right away, if your enrollment date has changed for any reason, or if you are having difficulties getting your fall schedule printed out and faxed to us. If we do not receive your class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, you will forfeit your scholarship.</p>

<p>Please either fax or mail your class schedule to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>Please e-mail the Cash for College scholarship office detailing your situation at <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>. Please remember to include your scholarship claim id number in your email.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail> graceGroup 3 - one time<br> --->
			<cfelseif daysToGo eq 4>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="REMINDER: 4 Days to Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>Your deadline to send us your Fall 2008 class schedule is just 4 days away - #DateFormat(deadlineDate, 'mmmm d, yyyy')#. Don't wait any longer to send it in!  We can't award your scholarship until we receive your class schedule.</p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers faxing services, and fax your fall class schedule to us.</p> 

<p>Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. </p>

<p>E-mail us as soon as possible if you have questions or concerns about sending us your schedule. E-mail <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>, and please remember to include your scholarship claim id number in your email. You can also refresh your memory about the Cash for College scholarship at our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail>	graceGroup 3 - 4 day reminder<br>
			<cfelseif daysToGo eq 2>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="2 Days LEFT Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>Your deadline to send us your Fall 2008 class schedule is just 2 days away - #DateFormat(deadlineDate, 'mmmm d, yyyy')#. Don't wait a minute longer to send us your class schedule! We can't award your scholarship until we receive your class schedule.</p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers Faxing services, and fax your fall class schedule to us.</p> 

<p>Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. </p>

<p>E-mail us as soon as possible if you have questions or concerns about sending us your schedule. E-mail <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>, and please remember to include your scholarship claim id number in your email. You can also refresh your memory about the Cash for College scholarship at our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail>	graceGroup 3 - 2 day reminder<br>	
			</cfif>		
		<cfelseif graceGroup eq 4>
			<cfif daysToGo eq 10>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="REMINDER: 10 Days to Send Your Fall 2008 Class Schedule! " type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>This is a friendly reminder from Cash for College, to make sure you send in your Fall 2008 class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#.  You have claimed your scholarship, and let us know when you'd be signing up (enrolling) for fall classes. Now, we need your Fall 2008 class schedule to finish awarding your scholarship. </p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers faxing services, and fax your fall class schedule to us. Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. Send us an e-mail right away if you are having trouble getting your Fall 2008 class schedule to us.</p>

<p>If you have questions check out our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>. If you need additional help, please e-mail our scholarship office detailing your question or concern at <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>. Please remember to include your scholarship claim id number in your email.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail> graceGroup 4 - 10 day reminder<br>
			<cfelseif daysToGo eq 4>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="REMINDER: 4 Days to Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>Your deadline to send us your Fall 2008 class schedule is just 4 days away - #DateFormat(deadlineDate, 'mmmm d, yyyy')#. Don't wait any longer to send it in!  We can't award your scholarship until we receive your class schedule.</p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers faxing services, and fax your fall class schedule to us.</p> 

<p>Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. </p>

<p>E-mail us as soon as possible if you have questions or concerns about sending us your schedule. E-mail <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>, and please remember to include your scholarship claim id number in your email. You can also refresh your memory about the Cash for College scholarship at our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail>	graceGroup 4 - 4 day reminder<br>
			<cfelseif daysToGo eq 2>
<cfmail to="#email#" from="cashforcollege@lachamber.org" subject="2 Days LEFT Send Your Fall 2008 Class Schedule!" type="html">
<p>Dear #firstName# #lastName# (#claimID#):</p>

<p>Your deadline to send us your Fall 2008 class schedule is just 2 days away - #DateFormat(deadlineDate, 'mmmm d, yyyy')#. Don't wait a minute longer to send us your class schedule! We can't award your scholarship until we receive your class schedule.</p>

<p>If you aren't mailing your class schedule in, look for places on campus like your financial aid or scholarship office, campus bookstore, library, or an off campus site that offers Faxing services, and fax your fall class schedule to us.</p> 

<p>Please make sure your class schedule includes obvious identification that it's from your campus (e.g. name or logo), and then fax or mail to:</p>

<table>
	<tr>
		<td valign="top">Fax:</td>
		<td>213-482-0814</td>
	</tr>
	<tr>
		<td valign="top">Mail:</td>
		<td>
		Cash for College Scholarship Administrator<br>
		350 S. Bixel Street, Suite 160<br>
		Los Angeles, CA 90017
		</td>
	</tr>
</table>

<p>We will accept your class schedule faxed or postmarked by the mail system on your deadline date, but no later. If you don't send in your fall class schedule by #DateFormat(deadlineDate, 'mmmm d, yyyy')#, we'll need to award this scholarship to an alternate recipient. </p>

<p>E-mail us as soon as possible if you have questions or concerns about sending us your schedule. E-mail <a href="mailto:cashforcollege@lachamber.org">cashforcollege@lachamber.org</a>, and please remember to include your scholarship claim id number in your email. You can also refresh your memory about the Cash for College scholarship at our <a href="http://www.calgrants.org/index.cfm?navid=158">Scholarship FAQs</a>.</p>

<p>All future communication about your scholarship will come to this email address, so be sure to check it often.</p>
</cfmail>	graceGroup 4 - 2 day reminder<br>	
			</cfif>		
	
		</cfif>
	
	</cfoutput>
</cfif>